package com.worthtech.billportal.dao;

import java.util.List;

import com.worthtech.billportal.bean.BillInfoOracle;
import com.worthtech.billportal.bean.CsHnOut;
import com.worthtech.billportal.bean.CsPosBin;
import com.worthtech.billportal.bean.CsPosCommercial;
import com.worthtech.billportal.bean.PepCardLimit;
import com.worthtech.billportal.bean.WtCommercial;
import com.worthtech.billportal.exception.SCException;

public interface BillOracleDAO {
	
	public BillInfoOracle saveBill(BillInfoOracle billInfoOracle)
	throws SCException;
	
	public List getListByHQL(String tableName, int startPage, int perNo,
			String orderby);
	public String getCount(String tableName, String condition);
	public String getSum(String list,String tableName, String condition);
	public List getListBySQL(String tableName, int startPage, int perNo,
			String orderby);
	public String getCountBySQL(String tableName, String condition) ;
	public String getSumBySQL(String list,String tableName, String condition);;
	public String getbySql(String sql);
	public void save(CsHnOut c);
	public void delete(CsHnOut c );
	public void save(PepCardLimit p);
	public void update(PepCardLimit p);
	public void delete(PepCardLimit p);
	
	public void save(CsPosBin p);
	public void update(CsPosBin p);
	public void delete(CsPosBin p);
	public void save(WtCommercial w);
	public void delete(WtCommercial w);
	public void update(WtCommercial w);
	
	public void save(CsPosCommercial c);
	public void update(CsPosCommercial c);
	public void delete(CsPosCommercial c);
	
	
}
